package com.zhaoyd.shardingdemo.mapper;


import com.zhaoyd.shardingdemo.entity.DemoItem;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface DemoItemMapper {

    @Select("select id, store_acct_id as storeAcctId, item_title as itemTitle from demo_item where store_acct_id=#{storeAcctId}")
    List<DemoItem> listByStoreAcctId(@Param("storeAcctId") Integer storeAcctId);

    @Select("select id, store_acct_id as storeAcctId, item_title as itemTitle from demo_item")
    List<DemoItem> listAll();
}